groups count, sum, average, bound, distinct-count and pick the first and last records